| RequirementRule |
| EntityType | Independent |
| Logical Entity Name | RequirementRule |
| Default Table Name | AdRequirementRule |
| Logical Only | NO |
| Definition | |
| Note |
| RequirementRule Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
RequirementRuleId |
INTEGER | NO | ||
| Code | CHAR(10) | NO | ||
| Name | VARCHAR(100) | NO | ||
| NumberOfCourses | INTEGER | YES | ||
| MinimumCredits | INTEGER | YES | ||
| IsAdvanced | BIT | NO | ||
| IsActive | BIT | NO | ||
LastModifiedUserId |
INTEGER | NO | ||
| CreatedDateTime | DATETIME | NO | ||
| LastModifiedDateTime | DATETIME | NO | ||
| RowVersion | TIMESTAMP/DATE | NO |
| RequirementRule Keys |
| Key Name | Key Type | Keys |
| UserID_N_N_IDX | Inversion Entry | LastModifiedUserId |
| Code_U_N_IDX | Alternate Key | Code |
| PK__AdRequirementRul__69969D9F | PrimaryKey | RequirementRuleId |
| RequirementRule Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| Staff | Non-Identifying | One To Zero or More | LastModifiedUserId | NO |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| AreaOfStudyRequirementRule | Non-Identifying | One To Zero or More | NO | ||||
| StudentEnrollmentDpaRequirementRule | Non-Identifying | Zero or One to Zero or More | NO | ||||
| AdConcentrationElectivePoolRequirementRule | Non-Identifying | One To Zero or More | NO | ||||
| AreaOfStudyRequirementRule | Identifying | One To Zero or More | NO | ||||
| AdConcentrationSubstitutePoolRequirementRule | Non-Identifying | One To Zero or More | NO | ||||
| StudentEnrollmentDpaRequirementRule | Non-Identifying | One To Zero or More | NO | ||||
| RequiredCourseCategoryRequirementRule | Identifying | One To Zero or More | NO | ||||
| AdProgramElectivePoolRequirementRule | Non-Identifying | One To Zero or More | NO | ||||
| ProgramRequirementRule | Identifying | One To Zero or More | NO | ||||
| AdProgramSubstitutePoolRequirementRule | Non-Identifying | One To Zero or More | NO | ||||
| AdProgramVersionRequirementRule | Non-Identifying | One To Zero or More | NO | ||||
| RequirementRuleAttribute | Identifying | One To Zero or More | NO | ||||
| RequirementRuleCourseLevel | Non-Identifying | One To Zero or More | NO | ||||
| AreaOfStudyRequirementRule | Non-Identifying | One To Zero or More | NO | ||||
| ProgramRequirementRule | Non-Identifying | One To Zero or More | NO | ||||
| RequiredCourseCategoryRequirementRule | Non-Identifying | One To Zero or More | NO | ||||
| RequirementRuleAttribute | Non-Identifying | One To Zero or More | NO | ||||
| RequirementRuleCourseLevel | Non-Identifying | One To Zero or More | NO | ||||
| StudentEnrollmentDpaRequirementRule | Non-Identifying | One To Zero or More | NO |
| RequirementRule Check Constraints |
| Check Constraint Name | CheckConstraint |